<?php

//Coded by Jonathan Gorard, 2012
//Part of The Matrix Unplugged, All Rights Reserved

	include "config.php";
	global $_CONFIG;
	
	if($_GET['code'] != $_CONFIG['code']) {
		die("");
	}

	define("MONO_ON", 1);
	require "class/class_db_{$_CONFIG['driver']}

.php";
$db=new database;
$db->configure($_CONFIG['hostname'], $_CONFIG['username'], $_CONFIG['password'], $_CONFIG['database'], $_CONFIG['persistent']);
$db->connect();
$c=$db->connection_id;
$db->query("UPDATE fedjail set fed_days=fed_days-1");
$q=$db->query("SELECT * FROM fedjail WHERE fed_days=0");
$ids=array();
while($r=$db->fetch_row($q)){
	$ids[]=$r['fed_userid'];
}


if(count($ids) > 0){
	$db->query("UPDATE users SET fedjail=0 WHERE userid IN(".implode(",", $ids).")");
}

$db->query("DELETE FROM fedjail WHERE fed_days=0");
$db->query("UPDATE users SET daysingang=daysingang+1 WHERE gang > 0");
$db->query("UPDATE users SET daysold=daysold+1, boxes_opened=0");
$db->query("UPDATE users SET mailban=mailban-1 WHERE mailban > 0");
$db->query("UPDATE users SET donatordays=donatordays-1 WHERE donatordays > 0");
$db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0");
$db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney/50) where bankmoney>0");
$db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*7) where cybermoney>0");
$q=$db->query("SELECT * FROM users WHERE cdays=0 AND course > 0");
while($r=$db->fetch_row($q)){
	$cd=$db->query("SELECT * FROM courses WHERE crID={$r['course']}

");
$coud=$db->fetch_row($cd);
$userid=$r['userid'];
$db->query("INSERT INTO coursesdone VALUES({$r['userid']}

,{$r['course']}

)");
$upd="";
$ev="";

if($coud['crSTR'] > 0){
	$upd.=",us.strength=us.strength+{$coud['crSTR']}

";
$ev.=", {$coud['crSTR']}

 Combat Skill";
}


if($coud['crGUARD'] > 0){
	$upd.=",us.guard=us.guard+{$coud['crGUARD']}

";
$ev.=", {$coud['crGUARD']}

 Hacking Skill";
}


if($coud['crLABOUR'] > 0){
	$upd.=",us.labour=us.labour+{$coud['crLABOUR']}

";
$ev.=", {$coud['crLABOUR']}

 Tactical Skill";
}


if($coud['crAGIL'] > 0){
	$upd.=",us.agility=us.agility+{$coud['crAGIL']}

";
$ev.=", {$coud['crAGIL']}

 Coding Skill";
}


if($coud['crIQ'] > 0){
	$upd.=",us.IQ=us.IQ+{$coud['crIQ']}

";
$ev.=", {$coud['crIQ']}

 IQ";
}

$ev=substr($ev,1);

if ($upd) {
	$db->query("UPDATE users u LEFT JOIN userstats us ON u.userid=us.userid SET us.userid=us.userid $upd WHERE u.userid=$userid");
}

$db->query("INSERT INTO events VALUES('',$userid,unix_timestamp(),0,'Congratulations, you finished running the {$coud['crNAME']}

 Training Program, and gained $ev!')");
}

$db->query("UPDATE users SET course=0 WHERE cdays=0");
$db->query("TRUNCATE TABLE votes;");
?>
